﻿

alter PROCEDURE [PomSelectCustomerAddressList]
(
	@pPomplingCustomerID VARCHAR(32)
)
AS
BEGIN
	SET NOCOUNT ON;
	SELECT a.[PomplingAddressID] , a.AddressLine1, a.AddressLine2, a.City, a.County, a.Postcode, a.DateAdded
	FROM PomPomplingAddresses a
	where a.Archived = 0 AND a.PomplingCustomerID = @pPomplingCustomerID AND a.Visible = 1
	order by a.City, AddressLine1 ASC

END